{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["UserInput","Coordinates","Calculations Circular","Calculations Rectangular","Results","Comparison"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"UserInput","index":0,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,4,0,10],[9,0,9,2],[16,0,16,2],[0,0,0,2],[23,0,23,2]]}
["Geometric Properties",null,null,null,"Cross-Section View"]
["Cross-Section","Circular"]
[{"$f":"IF(B2=\"Circular\",\"Diameter\",\"Height\")","v":"Diameter"},36,"in"]
[{"$f":"IF(B2=\"Circular\",\"\",\"Width\")","v":""},24,{"$f":"IF(B2=\"Circular\",\"\",\"in\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Results!D3=\"\",\"clr\",\"x\")","v":"x"}]
["No. Bars",10]
["Bar No.",9]
["Clear Cover",3,"in"]
["Ag",{"$f":"IF(B2=\"Circular\",B3^2*PI()/4,B4*B3)","v":1017.8760197630929},"in2"]
[]
["Concrete Properties"]
["f'c",4,"ksi"]
["εcu",3.0000000000000001E-3]
["Confinement","Spirals"]
["β'",{"$f":"IF(B11<=4,0.85,IF(B11<=5,0.8,IF(B11<=6,0.75,IF(B11<=7,0.7,0.65))))","v":0.85}]
["Ac",{"$f":"B8-B22","v":1007.88273919573},"in2"]
[]
["Steel Properties"]
["fy",60,"ksi"]
["Es",29000,"ksi"]
["db",{"$f":"IF(B6<=8,B6/8,IF(B6=9,1.128,IF(B6=10,1.27,IF(B6=11,1.41,IF(B6=14,1.693,IF(B6=18,2.257))))))","v":1.1279999999999999},"in"]
["Ab",{"$f":"B20^2*PI()/4","v":0.99932805673629865},"in2"]
["Total As",{"$f":"B21*B5","v":9.9932805673629872},"in2"]
[]
["AASHTO 5.6.4.2 Checks"]
["ρ = As/Ag",{"$f":"B22/B8","v":9.8177777777777777E-3}]
["Max ρ",0.08,null,null,"NOTE: Rebar diameters N.T.S."]
["Min ρ",{"$f":"MIN(0.015,0.135*B11/B18)","v":9.0000000000000011E-3},null,null,"NOTE: Clear Cover measured to edge of longitudinal bar."]
["Check",{"$f":"IF(B5<IF(B2=\"Circular\",6,4),\"Too few bars\",IF(B25>=B26,\"Over reinforced\",IF(B25<B27,\"Under reinforced\",\"OK\")))","v":"OK"}]

{"sheet":"Coordinates","index":1,"n_rows":39,"n_cols":21,"rows_kept":39,"cut":false,"hidden":true,"merged":[[0,0,0,2],[0,4,0,6],[0,8,0,10],[0,12,0,14],[0,16,0,18]]}
["Circle Coordinates",null,null,"X","Rebar Coordinates",null,null,null,"Rectangle Coordinates",null,null,null,"Rebar Coordinates",null,null,null,"Scaling Coordinates",null,null,null,"Circular"]
["Node No.","X","Y",null,"Bar No.","X","Y",null,"Node No.","X","Y",null,"Bar No.","X","Y",null,"Node No.","X","Y"]
[1,{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*COS((A3-1)*10*PI()/180),0)","v":18},{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*SIN((A3-1)*10*PI()/180),0)","v":0},null,1,4.4609693307967406,-13.729451869236836,null,1,0,0,null,null,null,null,null,1,{"$f":"IF(U1=\"Circular\",-UserInput!B3/2,UserInput!B4/2-MAX(UserInput!B3:B4)/2)","v":-18},{"$f":"IF(U1=\"Circular\",-UserInput!B3/2,UserInput!B3/2-MAX(UserInput!B3:B4)/2)","v":-18}]
[2,{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*COS((A4-1)*10*PI()/180),0)","v":17.726539554219745},{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*SIN((A4-1)*10*PI()/180),0)","v":3.1256671980047459},null,2,11.678969330796741,-8.4852679020941419,null,2,{"$f":"IF($L$1=\"X\",UserInput!B4,0)","v":0},0,null,null,null,null,null,2,{"$f":"IF(U1=\"Circular\",UserInput!B3/2,UserInput!B4-(UserInput!B4/2-MAX(UserInput!B3:B4)/2))","v":18},{"$f":"IF(U1=\"Circular\",UserInput!B3/2,UserInput!B3-(UserInput!B3/2-MAX(UserInput!B3:B4)/2))","v":18}]
[3,{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*COS((A5-1)*10*PI()/180),0)","v":16.914467174146353},{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*SIN((A5-1)*10*PI()/180),0)","v":6.1563625798620372},null,3,14.436,-8.8395005962455958E-16,null,3,{"$f":"J4","v":0},{"$f":"IF(L1=\"X\",UserInput!B3,0)","v":0}]
[4,{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*COS((A6-1)*10*PI()/180),0)","v":15.588457268119896},{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*SIN((A6-1)*10*PI()/180),0)","v":8.9999999999999982},null,4,11.678969330796741,8.4852679020941402,null,4,0,{"$f":"K5","v":0}]
[5,{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*COS((A7-1)*10*PI()/180),0)","v":13.788799976141604},{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*SIN((A7-1)*10*PI()/180),0)","v":11.570176974357707},null,5,4.4609693307967424,13.729451869236836,null,5,0,0]
[6,{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*COS((A8-1)*10*PI()/180),0)","v":11.570176974357709},{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*SIN((A8-1)*10*PI()/180),0)","v":13.788799976141604},null,6,-4.4609693307967389,13.729451869236838]
[7,{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*COS((A9-1)*10*PI()/180),0)","v":9.0000000000000018},{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*SIN((A9-1)*10*PI()/180),0)","v":15.588457268119894},null,7,-11.67896933079674,8.4852679020941437]
[8,{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*COS((A10-1)*10*PI()/180),0)","v":6.1563625798620389},{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*SIN((A10-1)*10*PI()/180),0)","v":16.914467174146349},null,8,-14.436,2.6518501788736785E-15]
[9,{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*COS((A11-1)*10*PI()/180),0)","v":3.1256671980047477},{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*SIN((A11-1)*10*PI()/180),0)","v":17.726539554219745},null,9,-11.678969330796743,-8.4852679020941384]
[10,{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*COS((A12-1)*10*PI()/180),0)","v":1.102633609417758E-15},{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*SIN((A12-1)*10*PI()/180),0)","v":18},null,10,-4.4609693307967442,-13.729451869236836]
[11,{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*COS((A13-1)*10*PI()/180),0)","v":-3.1256671980047455},{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*SIN((A13-1)*10*PI()/180),0)","v":17.726539554219745}]
[12,{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*COS((A14-1)*10*PI()/180),0)","v":-6.1563625798620372},{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*SIN((A14-1)*10*PI()/180),0)","v":16.914467174146353}]
[13,{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*COS((A15-1)*10*PI()/180),0)","v":-8.9999999999999964},{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*SIN((A15-1)*10*PI()/180),0)","v":15.588457268119896}]
[14,{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*COS((A16-1)*10*PI()/180),0)","v":-11.570176974357709},{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*SIN((A16-1)*10*PI()/180),0)","v":13.788799976141604}]
[15,{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*COS((A17-1)*10*PI()/180),0)","v":-13.788799976141602},{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*SIN((A17-1)*10*PI()/180),0)","v":11.570176974357711}]
[16,{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*COS((A18-1)*10*PI()/180),0)","v":-15.588457268119896},{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*SIN((A18-1)*10*PI()/180),0)","v":8.9999999999999982}]
[17,{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*COS((A19-1)*10*PI()/180),0)","v":-16.914467174146349},{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*SIN((A19-1)*10*PI()/180),0)","v":6.1563625798620398}]
[18,{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*COS((A20-1)*10*PI()/180),0)","v":-17.726539554219745},{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*SIN((A20-1)*10*PI()/180),0)","v":3.125667198004745}]
[19,{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*COS((A21-1)*10*PI()/180),0)","v":-18},{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*SIN((A21-1)*10*PI()/180),0)","v":2.205267218835516E-15}]
[20,{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*COS((A22-1)*10*PI()/180),0)","v":-17.726539554219745},{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*SIN((A22-1)*10*PI()/180),0)","v":-3.1256671980047486}]
[21,{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*COS((A23-1)*10*PI()/180),0)","v":-16.914467174146353},{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*SIN((A23-1)*10*PI()/180),0)","v":-6.1563625798620354}]
[22,{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*COS((A24-1)*10*PI()/180),0)","v":-15.588457268119894},{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*SIN((A24-1)*10*PI()/180),0)","v":-9.0000000000000018}]
[23,{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*COS((A25-1)*10*PI()/180),0)","v":-13.788799976141604},{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*SIN((A25-1)*10*PI()/180),0)","v":-11.570176974357707}]
[24,{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*COS((A26-1)*10*PI()/180),0)","v":-11.570176974357711},{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*SIN((A26-1)*10*PI()/180),0)","v":-13.788799976141602}]
[25,{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*COS((A27-1)*10*PI()/180),0)","v":-9.0000000000000071},{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*SIN((A27-1)*10*PI()/180),0)","v":-15.588457268119891}]
[26,{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*COS((A28-1)*10*PI()/180),0)","v":-6.1563625798620487},{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*SIN((A28-1)*10*PI()/180),0)","v":-16.914467174146349}]
[27,{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*COS((A29-1)*10*PI()/180),0)","v":-3.1256671980047459},{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*SIN((A29-1)*10*PI()/180),0)","v":-17.726539554219745}]
[28,{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*COS((A30-1)*10*PI()/180),0)","v":-3.307900828253274E-15},{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*SIN((A30-1)*10*PI()/180),0)","v":-18}]
[29,{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*COS((A31-1)*10*PI()/180),0)","v":3.1256671980047397},{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*SIN((A31-1)*10*PI()/180),0)","v":-17.726539554219748}]
[30,{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*COS((A32-1)*10*PI()/180),0)","v":6.1563625798620265},{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*SIN((A32-1)*10*PI()/180),0)","v":-16.914467174146353}]
[31,{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*COS((A33-1)*10*PI()/180),0)","v":9.0000000000000018},{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*SIN((A33-1)*10*PI()/180),0)","v":-15.588457268119894}]
[32,{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*COS((A34-1)*10*PI()/180),0)","v":11.570176974357707},{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*SIN((A34-1)*10*PI()/180),0)","v":-13.788799976141606}]
[33,{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*COS((A35-1)*10*PI()/180),0)","v":13.7887999761416},{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*SIN((A35-1)*10*PI()/180),0)","v":-11.570176974357713}]
[34,{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*COS((A36-1)*10*PI()/180),0)","v":15.588457268119891},{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*SIN((A36-1)*10*PI()/180),0)","v":-9.0000000000000071}]
[35,{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*COS((A37-1)*10*PI()/180),0)","v":16.914467174146353},{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*SIN((A37-1)*10*PI()/180),0)","v":-6.1563625798620345}]
[36,{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*COS((A38-1)*10*PI()/180),0)","v":17.726539554219741},{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*SIN((A38-1)*10*PI()/180),0)","v":-3.1256671980047628}]
[37,{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*COS((A39-1)*10*PI()/180),0)","v":18},{"$f":"IF($D$1=\"X\",UserInput!$B$3/2*SIN((A39-1)*10*PI()/180),0)","v":-4.410534437671032E-15}]

{"sheet":"Calculations Circular","index":2,"n_rows":63,"n_cols":18,"rows_kept":63,"cut":false,"hidden":true,"merged":[]}
["Strains","d=",{"$f":"UserInput!B3/2-MIN(Coordinates!G3:G103)","v":31.729451869236836},null,"εsbars"]
["εsmax description","c","εc","εsmax",1,2,3,4,5,6,7,8,9,10]
["compression","N/A",{"$f":"-UserInput!$B$12","v":-3.0000000000000001E-3},-3.0000000000000001E-3,-3.0000000000000001E-3,-3.0000000000000001E-3,-3.0000000000000001E-3,-3.0000000000000001E-3,-3.0000000000000001E-3,-3.0000000000000001E-3,-3.0000000000000001E-3,-3.0000000000000001E-3,-3.0000000000000001E-3,-3.0000000000000001E-3]
["0εsy",{"$f":"$C$1*(-C4/(D4-C4))","v":31.729451869236836},{"$f":"-UserInput!$B$12","v":-3.0000000000000001E-3},0,0,-4.9583434237266224E-4,-1.298111161121082E-3,-2.1003879798695015E-3,-2.596222322242164E-3,-2.596222322242164E-3,-2.1003879798695019E-3,-1.298111161121082E-3,-4.9583434237266257E-4,0]
[0.25,{"$f":"$C$1*(-C5/(D5-C5))","v":27.063356006113775},{"$f":"-UserInput!$B$12","v":-3.0000000000000001E-3},{"$f":"A5*UserInput!$B$18/UserInput!$B$19","v":5.1724137931034484E-4},5.1724137931034452E-4,-6.4081642781742165E-5,-1.0046820509695444E-3,-1.9452824591573465E-3,-2.5266054812494334E-3,-2.5266054812494334E-3,-1.9452824591573469E-3,-1.0046820509695446E-3,-6.4081642781742558E-5,5.1724137931034452E-4]
[{"$f":"A5+0.25","v":0.5},23.59369497968893,{"$f":"-UserInput!$B$12","v":-3.0000000000000001E-3},{"$f":"A6*UserInput!$B$18/UserInput!$B$19","v":1.0344827586206897E-3},1.0344827586206895E-3,3.6767105680917832E-4,-7.112529408180064E-4,-1.7901769384451912E-3,-2.4569886402567025E-3,-2.4569886402567025E-3,-1.7901769384451917E-3,-7.1125294081800683E-4,3.6767105680917788E-4,1.0344827586206895E-3]
[{"$f":"A6+0.25","v":0.75},20.912593277451549,{"$f":"-UserInput!$B$12","v":-3.0000000000000001E-3},{"$f":"A7*UserInput!$B$18/UserInput!$B$19","v":1.5517241379310344E-3},1.5517241379310349E-3,7.9942375640009919E-4,-4.1782383066646855E-4,-1.6350714177330362E-3,-2.3873717992639724E-3,-2.3873717992639728E-3,-1.6350714177330366E-3,-4.1782383066646904E-4,7.9942375640009865E-4,1.5517241379310349E-3]
[{"$f":"A7+0.25","v":1},18.778655187915678,{"$f":"-UserInput!$B$12","v":-3.0000000000000001E-3},{"$f":"A8*UserInput!$B$18/UserInput!$B$19","v":2.0689655172413794E-3},2.0689655172413794E-3,1.2311764559910193E-3,-1.2439472051493111E-4,-1.4799658970208814E-3,-2.3177549582712419E-3,-2.3177549582712423E-3,-1.479965897020882E-3,-1.2439472051493168E-4,1.2311764559910187E-3,2.0689655172413794E-3]
[{"$f":"A8+1","v":2},13.335566727650264,{"$f":"-UserInput!$B$12","v":-3.0000000000000001E-3},{"$f":"A9*UserInput!$B$18/UserInput!$B$19","v":4.1379310344827587E-3},4.1379310344827587E-3,2.9581872543547006E-3,1.0493217200912197E-3,-8.5954381417226145E-4,-2.0392875943003202E-3,-2.0392875943003206E-3,-8.5954381417226232E-4,1.0493217200912188E-3,2.9581872543546998E-3,4.1379310344827587E-3]
[{"$f":"A9+1","v":3},10.338810159638969,{"$f":"-UserInput!$B$12","v":-3.0000000000000001E-3},{"$f":"A10*UserInput!$B$18/UserInput!$B$19","v":6.2068965517241377E-3},6.2068965517241368E-3,4.6851980527183815E-3,2.2230381606973696E-3,-2.3912173132364183E-4,-1.7608202303293985E-3,-1.7608202303293992E-3,-2.3912173132364286E-4,2.2230381606973687E-3,4.6851980527183807E-3,6.2068965517241368E-3]
[{"$f":"A10+1","v":4},8.4417807725492491,{"$f":"-UserInput!$B$12","v":-3.0000000000000001E-3},{"$f":"A11*UserInput!$B$18/UserInput!$B$19","v":8.2758620689655175E-3},8.2758620689655192E-3,6.4122088510820642E-3,3.396754601303521E-3,3.8130035152497839E-4,-1.4823528663584769E-3,-1.4823528663584775E-3,3.8130035152497715E-4,3.3967546013035201E-3,6.4122088510820624E-3,8.2758620689655192E-3]
[{"$f":"A11+2","v":6},6.1755309007239481,{"$f":"-UserInput!$B$12","v":-3.0000000000000001E-3},{"$f":"A12*UserInput!$B$18/UserInput!$B$19","v":1.2413793103448275E-2},1.2413793103448275E-2,9.8662304478094251E-3,5.7441874825158203E-3,1.6221445172222172E-3,-9.2541813841663417E-4,-9.2541813841663504E-4,1.6221445172222154E-3,5.7441874825158194E-3,9.8662304478094216E-3,1.2413793103448275E-2]
[{"$f":"A12+2","v":8},4.8685402339040653,{"$f":"-UserInput!$B$12","v":-3.0000000000000001E-3},{"$f":"A13*UserInput!$B$18/UserInput!$B$19","v":1.6551724137931035E-2},1.6551724137931031E-2,1.3320252044536785E-2,8.0916203637281196E-3,2.8629886829194566E-3,-3.6848341047479062E-4,-3.6848341047479171E-4,2.8629886829194544E-3,8.0916203637281196E-3,1.3320252044536783E-2,1.6551724137931031E-2]
[{"$f":"A13+2","v":10},4.0181401930474605,{"$f":"-UserInput!$B$12","v":-3.0000000000000001E-3},{"$f":"A14*UserInput!$B$18/UserInput!$B$19","v":2.0689655172413793E-2},2.0689655172413793E-2,1.6774273641264149E-2,1.0439053244940422E-2,4.103832848616696E-3,1.8845131746705158E-4,1.8845131746705025E-4,4.1038328486166925E-3,1.0439053244940421E-2,1.6774273641264149E-2,2.0689655172413793E-2]
["tension","N/A",{"$f":"-UserInput!$B$12","v":-3.0000000000000001E-3},2.0689655172413794E-3,2.0689655172413794E-3,2.0689655172413794E-3,2.0689655172413794E-3,2.0689655172413794E-3,2.0689655172413794E-3,2.0689655172413794E-3,2.0689655172413794E-3,2.0689655172413794E-3,2.0689655172413794E-3,2.0689655172413794E-3]
[]
["Stresses (ksi)"]
["Point No.","c","fc","fsmax",1,2,3,4,5,6,7,8,9,10]
[1,"N/A",{"$f":"0.85*UserInput!$B$11","v":3.4},{"$f":"IF(D3<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(D3>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!D3*UserInput!$B$19))","v":-60},{"$f":"IF(E3<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(E3>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!E3*UserInput!$B$19))","v":-60},{"$f":"IF(F3<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(F3>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!F3*UserInput!$B$19))","v":-60},{"$f":"IF(G3<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(G3>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!G3*UserInput!$B$19))","v":-60},{"$f":"IF(H3<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(H3>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!H3*UserInput!$B$19))","v":-60},{"$f":"IF(I3<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(I3>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!I3*UserInput!$B$19))","v":-60},{"$f":"IF(J3<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(J3>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!J3*UserInput!$B$19))","v":-60},{"$f":"IF(K3<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(K3>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!K3*UserInput!$B$19))","v":-60},{"$f":"IF(L3<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(L3>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!L3*UserInput!$B$19))","v":-60},{"$f":"IF(M3<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(M3>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!M3*UserInput!$B$19))","v":-60},{"$f":"IF(N3<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(N3>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!N3*UserInput!$B$19))","v":-60}]
[{"$f":"A19+1","v":2},{"$f":"B4","v":31.729451869236836},{"$f":"$C$19","v":3.4},{"$f":"IF(D4<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(D4>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!D4*UserInput!$B$19))","v":0},{"$f":"IF(E4<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(E4>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!E4*UserInput!$B$19))","v":0},{"$f":"IF(F4<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(F4>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!F4*UserInput!$B$19))","v":-14.379195928807205},{"$f":"IF(G4<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(G4>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!G4*UserInput!$B$19))","v":-37.645223672511378},{"$f":"IF(H4<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(H4>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!H4*UserInput!$B$19))","v":-60},{"$f":"IF(I4<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(I4>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!I4*UserInput!$B$19))","v":-60},{"$f":"IF(J4<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(J4>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!J4*UserInput!$B$19))","v":-60},{"$f":"IF(K4<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(K4>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!K4*UserInput!$B$19))","v":-60},{"$f":"IF(L4<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(L4>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!L4*UserInput!$B$19))","v":-37.645223672511378},{"$f":"IF(M4<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(M4>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!M4*UserInput!$B$19))","v":-14.379195928807214},{"$f":"IF(N4<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(N4>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!N4*UserInput!$B$19))","v":0}]
[3,27.063356006113775,{"$f":"$C$19","v":3.4},{"$f":"IF(D5<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(D5>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!D5*UserInput!$B$19))","v":15},{"$f":"IF(E5<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(E5>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!E5*UserInput!$B$19))","v":14.999999999999991},{"$f":"IF(F5<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(F5>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!F5*UserInput!$B$19))","v":-1.8583676406705227},{"$f":"IF(G5<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(G5>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!G5*UserInput!$B$19))","v":-29.135779478116785},{"$f":"IF(H5<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(H5>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!H5*UserInput!$B$19))","v":-56.413191315563047},{"$f":"IF(I5<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(I5>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!I5*UserInput!$B$19))","v":-60},{"$f":"IF(J5<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(J5>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!J5*UserInput!$B$19))","v":-60},{"$f":"IF(K5<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(K5>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!K5*UserInput!$B$19))","v":-56.413191315563061},{"$f":"IF(L5<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(L5>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!L5*UserInput!$B$19))","v":-29.135779478116792},{"$f":"IF(M5<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(M5>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!M5*UserInput!$B$19))","v":-1.8583676406705343},{"$f":"IF(N5<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(N5>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!N5*UserInput!$B$19))","v":14.999999999999991}]
[4,23.59369497968893,3.4,{"$f":"IF(D6<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(D6>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!D6*UserInput!$B$19))","v":30},{"$f":"IF(E6<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(E6>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!E6*UserInput!$B$19))","v":29.999999999999993},{"$f":"IF(F6<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(F6>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!F6*UserInput!$B$19))","v":10.662460647466171},{"$f":"IF(G6<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(G6>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!G6*UserInput!$B$19))","v":-20.626335283722184},{"$f":"IF(H6<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(H6>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!H6*UserInput!$B$19))","v":-51.915131214910545},{"$f":"IF(I6<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(I6>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!I6*UserInput!$B$19))","v":-60},{"$f":"IF(J6<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(J6>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!J6*UserInput!$B$19))","v":-60},{"$f":"IF(K6<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(K6>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!K6*UserInput!$B$19))","v":-51.915131214910559},{"$f":"IF(L6<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(L6>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!L6*UserInput!$B$19))","v":-20.626335283722199},{"$f":"IF(M6<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(M6>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!M6*UserInput!$B$19))","v":10.662460647466158},{"$f":"IF(N6<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(N6>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!N6*UserInput!$B$19))","v":29.999999999999993}]
[5,20.912593277451549,3.4,{"$f":"IF(D7<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(D7>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!D7*UserInput!$B$19))","v":45},{"$f":"IF(E7<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(E7>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!E7*UserInput!$B$19))","v":45.000000000000014},{"$f":"IF(F7<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(F7>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!F7*UserInput!$B$19))","v":23.183288935602878},{"$f":"IF(G7<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(G7>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!G7*UserInput!$B$19))","v":-12.116891089327588},{"$f":"IF(H7<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(H7>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!H7*UserInput!$B$19))","v":-47.41707111425805},{"$f":"IF(I7<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(I7>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!I7*UserInput!$B$19))","v":-60},{"$f":"IF(J7<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(J7>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!J7*UserInput!$B$19))","v":-60},{"$f":"IF(K7<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(K7>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!K7*UserInput!$B$19))","v":-47.417071114258064},{"$f":"IF(L7<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(L7>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!L7*UserInput!$B$19))","v":-12.116891089327602},{"$f":"IF(M7<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(M7>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!M7*UserInput!$B$19))","v":23.18328893560286},{"$f":"IF(N7<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(N7>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!N7*UserInput!$B$19))","v":45.000000000000014}]
[6,18.778655187915678,3.4,{"$f":"IF(D8<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(D8>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!D8*UserInput!$B$19))","v":60},{"$f":"IF(E8<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(E8>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!E8*UserInput!$B$19))","v":60},{"$f":"IF(F8<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(F8>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!F8*UserInput!$B$19))","v":35.704117223739559},{"$f":"IF(G8<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(G8>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!G8*UserInput!$B$19))","v":-3.6074468949330023},{"$f":"IF(H8<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(H8>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!H8*UserInput!$B$19))","v":-42.919011013605562},{"$f":"IF(I8<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(I8>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!I8*UserInput!$B$19))","v":-60},{"$f":"IF(J8<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(J8>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!J8*UserInput!$B$19))","v":-60},{"$f":"IF(K8<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(K8>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!K8*UserInput!$B$19))","v":-42.919011013605576},{"$f":"IF(L8<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(L8>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!L8*UserInput!$B$19))","v":-3.6074468949330187},{"$f":"IF(M8<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(M8>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!M8*UserInput!$B$19))","v":35.704117223739544},{"$f":"IF(N8<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(N8>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!N8*UserInput!$B$19))","v":60}]
[7,13.335566727650264,3.4,{"$f":"IF(D9<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(D9>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!D9*UserInput!$B$19))","v":60},{"$f":"IF(E9<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(E9>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!E9*UserInput!$B$19))","v":60},{"$f":"IF(F9<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(F9>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!F9*UserInput!$B$19))","v":60},{"$f":"IF(G9<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(G9>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!G9*UserInput!$B$19))","v":30.430329882645371},{"$f":"IF(H9<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(H9>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!H9*UserInput!$B$19))","v":-24.926770610995582},{"$f":"IF(I9<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(I9>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!I9*UserInput!$B$19))","v":-59.139340234709287},{"$f":"IF(J9<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(J9>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!J9*UserInput!$B$19))","v":-59.139340234709302},{"$f":"IF(K9<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(K9>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!K9*UserInput!$B$19))","v":-24.926770610995607},{"$f":"IF(L9<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(L9>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!L9*UserInput!$B$19))","v":30.430329882645346},{"$f":"IF(M9<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(M9>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!M9*UserInput!$B$19))","v":60},{"$f":"IF(N9<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(N9>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!N9*UserInput!$B$19))","v":60}]
[8,10.338810159638969,3.4,{"$f":"IF(D10<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(D10>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!D10*UserInput!$B$19))","v":60},{"$f":"IF(E10<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(E10>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!E10*UserInput!$B$19))","v":60},{"$f":"IF(F10<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(F10>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!F10*UserInput!$B$19))","v":60},{"$f":"IF(G10<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(G10>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!G10*UserInput!$B$19))","v":60},{"$f":"IF(H10<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(H10>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!H10*UserInput!$B$19))","v":-6.9345302083856133},{"$f":"IF(I10<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(I10>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!I10*UserInput!$B$19))","v":-51.063786679552557},{"$f":"IF(J10<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(J10>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!J10*UserInput!$B$19))","v":-51.063786679552578},{"$f":"IF(K10<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(K10>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!K10*UserInput!$B$19))","v":-6.9345302083856426},{"$f":"IF(L10<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(L10>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!L10*UserInput!$B$19))","v":60},{"$f":"IF(M10<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(M10>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!M10*UserInput!$B$19))","v":60},{"$f":"IF(N10<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(N10>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!N10*UserInput!$B$19))","v":60}]
[9,8.4417807725492491,3.4,{"$f":"IF(D11<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(D11>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!D11*UserInput!$B$19))","v":60},{"$f":"IF(E11<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(E11>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!E11*UserInput!$B$19))","v":60},{"$f":"IF(F11<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(F11>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!F11*UserInput!$B$19))","v":60},{"$f":"IF(G11<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(G11>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!G11*UserInput!$B$19))","v":60},{"$f":"IF(H11<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(H11>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!H11*UserInput!$B$19))","v":11.057710194224374},{"$f":"IF(I11<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(I11>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!I11*UserInput!$B$19))","v":-42.988233124395826},{"$f":"IF(J11<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(J11>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!J11*UserInput!$B$19))","v":-42.988233124395848},{"$f":"IF(K11<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(K11>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!K11*UserInput!$B$19))","v":11.057710194224338},{"$f":"IF(L11<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(L11>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!L11*UserInput!$B$19))","v":60},{"$f":"IF(M11<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(M11>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!M11*UserInput!$B$19))","v":60},{"$f":"IF(N11<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(N11>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!N11*UserInput!$B$19))","v":60}]
[10,6.1755309007239481,3.4,{"$f":"IF(D12<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(D12>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!D12*UserInput!$B$19))","v":60},{"$f":"IF(E12<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(E12>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!E12*UserInput!$B$19))","v":60},{"$f":"IF(F12<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(F12>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!F12*UserInput!$B$19))","v":60},{"$f":"IF(G12<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(G12>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!G12*UserInput!$B$19))","v":60},{"$f":"IF(H12<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(H12>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!H12*UserInput!$B$19))","v":47.042190999444294},{"$f":"IF(I12<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(I12>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!I12*UserInput!$B$19))","v":-26.83712601408239},{"$f":"IF(J12<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(J12>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!J12*UserInput!$B$19))","v":-26.837126014082415},{"$f":"IF(K12<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(K12>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!K12*UserInput!$B$19))","v":47.042190999444244},{"$f":"IF(L12<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(L12>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!L12*UserInput!$B$19))","v":60},{"$f":"IF(M12<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(M12>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!M12*UserInput!$B$19))","v":60},{"$f":"IF(N12<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(N12>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!N12*UserInput!$B$19))","v":60}]
[11,4.8685402339040653,3.4,{"$f":"IF(D13<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(D13>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!D13*UserInput!$B$19))","v":60},{"$f":"IF(E13<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(E13>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!E13*UserInput!$B$19))","v":60},{"$f":"IF(F13<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(F13>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!F13*UserInput!$B$19))","v":60},{"$f":"IF(G13<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(G13>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!G13*UserInput!$B$19))","v":60},{"$f":"IF(H13<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(H13>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!H13*UserInput!$B$19))","v":60},{"$f":"IF(I13<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(I13>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!I13*UserInput!$B$19))","v":-10.686018903768929},{"$f":"IF(J13<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(J13>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!J13*UserInput!$B$19))","v":-10.686018903768959},{"$f":"IF(K13<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(K13>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!K13*UserInput!$B$19))","v":60},{"$f":"IF(L13<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(L13>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!L13*UserInput!$B$19))","v":60},{"$f":"IF(M13<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(M13>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!M13*UserInput!$B$19))","v":60},{"$f":"IF(N13<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(N13>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!N13*UserInput!$B$19))","v":60}]
[12,4.0181401930474605,3.4,{"$f":"IF(D14<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(D14>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!D14*UserInput!$B$19))","v":60},{"$f":"IF(E14<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(E14>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!E14*UserInput!$B$19))","v":60},{"$f":"IF(F14<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(F14>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!F14*UserInput!$B$19))","v":60},{"$f":"IF(G14<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(G14>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!G14*UserInput!$B$19))","v":60},{"$f":"IF(H14<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(H14>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!H14*UserInput!$B$19))","v":60},{"$f":"IF(I14<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(I14>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!I14*UserInput!$B$19))","v":5.4650882065444959},{"$f":"IF(J14<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(J14>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!J14*UserInput!$B$19))","v":5.4650882065444568},{"$f":"IF(K14<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(K14>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!K14*UserInput!$B$19))","v":60},{"$f":"IF(L14<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(L14>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!L14*UserInput!$B$19))","v":60},{"$f":"IF(M14<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(M14>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!M14*UserInput!$B$19))","v":60},{"$f":"IF(N14<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(N14>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!N14*UserInput!$B$19))","v":60}]
[13,"N/A",3.4,{"$f":"IF(D15<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(D15>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!D15*UserInput!$B$19))","v":60},{"$f":"IF(E15<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(E15>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!E15*UserInput!$B$19))","v":60},{"$f":"IF(F15<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(F15>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!F15*UserInput!$B$19))","v":60},{"$f":"IF(G15<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(G15>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!G15*UserInput!$B$19))","v":60},{"$f":"IF(H15<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(H15>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!H15*UserInput!$B$19))","v":60},{"$f":"IF(I15<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(I15>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!I15*UserInput!$B$19))","v":60},{"$f":"IF(J15<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(J15>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!J15*UserInput!$B$19))","v":60},{"$f":"IF(K15<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(K15>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!K15*UserInput!$B$19))","v":60},{"$f":"IF(L15<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(L15>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!L15*UserInput!$B$19))","v":60},{"$f":"IF(M15<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(M15>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!M15*UserInput!$B$19))","v":60},{"$f":"IF(N15<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(N15>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Circular'!N15*UserInput!$B$19))","v":60}]
[]
["Forces (kip)"]
["Point No.","c","a=β'c","Ascomp","Accomp","C arm","C","Tbar max",1,2,3,4,5,6,7,8,9,10]
[1,"N/A","N/A",{"$f":"UserInput!$B$21*UserInput!$B$5","v":9.9932805673629872},{"$f":"UserInput!B8-D35","v":1007.88273919573},0,{"$f":"-E35*C19","v":-3426.8013132654819},{"$f":"D19*UserInput!$B$21","v":-59.959683404177916},{"$f":"E19*UserInput!$B$21","v":-59.959683404177916},{"$f":"F19*UserInput!$B$21","v":-59.959683404177916},{"$f":"G19*UserInput!$B$21","v":-59.959683404177916},{"$f":"H19*UserInput!$B$21","v":-59.959683404177916},{"$f":"I19*UserInput!$B$21","v":-59.959683404177916},{"$f":"J19*UserInput!$B$21","v":-59.959683404177916},{"$f":"K19*UserInput!$B$21","v":-59.959683404177916},{"$f":"L19*UserInput!$B$21","v":-59.959683404177916},{"$f":"M19*UserInput!$B$21","v":-59.959683404177916},{"$f":"N19*UserInput!$B$21","v":-59.959683404177916}]
[{"$f":"A35+1","v":2},{"$f":"B20","v":31.729451869236836},{"$f":"B36*UserInput!$B$14","v":26.97003408885131},{"$f":"UserInput!$B$21*COUNTIF(Coordinates!$G$3:$G$103,\">\"&UserInput!$B$3-'Calculations Circular'!C36-UserInput!$B$3/2)","v":7.9946244538903892},{"$f":"(UserInput!$B$3/2)^2*ACOS(((UserInput!$B$3/2)-C36)/(UserInput!$B$3/2))-((UserInput!$B$3/2)-C36)*SQRT(2*(UserInput!$B$3/2)*C36-C36^2)","v":817.94536626909212},{"$f":"2*(2*(UserInput!$B$3/2)*C36-C36^2)^(3/2)/(3*E36)","v":3.0976750217208409},-2781.0142453149133,{"$f":"D20*UserInput!$B$21","v":0},{"$f":"E20*UserInput!$B$21","v":0},{"$f":"F20*UserInput!$B$21","v":-14.369533924965401},{"$f":"G20*UserInput!$B$21","v":-37.619928218054106},{"$f":"H20*UserInput!$B$21","v":-59.959683404177916},{"$f":"I20*UserInput!$B$21","v":-59.959683404177916},{"$f":"J20*UserInput!$B$21","v":-59.959683404177916},{"$f":"K20*UserInput!$B$21","v":-59.959683404177916},{"$f":"L20*UserInput!$B$21","v":-37.619928218054106},{"$f":"M20*UserInput!$B$21","v":-14.36953392496541},{"$f":"N20*UserInput!$B$21","v":0}]
[3,27.063356006113775,{"$f":"B37*UserInput!$B$14","v":23.003852605196709},{"$f":"UserInput!$B$21*COUNTIF(Coordinates!$G$3:$G$103,\">\"&UserInput!$B$3-'Calculations Circular'!C37-UserInput!$B$3/2)","v":5.9959683404177921},{"$f":"(UserInput!$B$3/2)^2*ACOS(((UserInput!$B$3/2)-C37)/(UserInput!$B$3/2))-((UserInput!$B$3/2)-C37)*SQRT(2*(UserInput!$B$3/2)*C37-C37^2)","v":686.72886718717064},{"$f":"2*(2*(UserInput!$B$3/2)*C37-C37^2)^(3/2)/(3*E37)","v":5.0181801007907865},-2334.8781484363799,{"$f":"D21*UserInput!$B$21","v":14.989920851044479},{"$f":"E21*UserInput!$B$21","v":14.98992085104447},{"$f":"F21*UserInput!$B$21","v":-1.8571189230528937},{"$f":"G21*UserInput!$B$21","v":-29.116201887363776},{"$f":"H21*UserInput!$B$21","v":-56.375284851674657},{"$f":"I21*UserInput!$B$21","v":-59.959683404177916},{"$f":"J21*UserInput!$B$21","v":-59.959683404177916},{"$f":"K21*UserInput!$B$21","v":-56.375284851674671},{"$f":"L21*UserInput!$B$21","v":-29.116201887363783},{"$f":"M21*UserInput!$B$21","v":-1.857118923052905},{"$f":"N21*UserInput!$B$21","v":14.98992085104447}]
[4,23.59369497968893,{"$f":"B38*UserInput!$B$14","v":20.054640732735589},{"$f":"UserInput!$B$21*COUNTIF(Coordinates!$G$3:$G$103,\">\"&UserInput!$B$3-'Calculations Circular'!C38-UserInput!$B$3/2)","v":5.9959683404177921},{"$f":"(UserInput!$B$3/2)^2*ACOS(((UserInput!$B$3/2)-C38)/(UserInput!$B$3/2))-((UserInput!$B$3/2)-C38)*SQRT(2*(UserInput!$B$3/2)*C38-C38^2)","v":582.74413557185176},{"$f":"2*(2*(UserInput!$B$3/2)*C38-C38^2)^(3/2)/(3*E38)","v":6.541910856172044},-1981.3300609442958,{"$f":"D22*UserInput!$B$21","v":29.979841702088958},{"$f":"E22*UserInput!$B$21","v":29.979841702088951},{"$f":"F22*UserInput!$B$21","v":10.655296078859624},{"$f":"G22*UserInput!$B$21","v":-20.612475556673441},{"$f":"H22*UserInput!$B$21","v":-51.880247192206511},{"$f":"I22*UserInput!$B$21","v":-59.959683404177916},{"$f":"J22*UserInput!$B$21","v":-59.959683404177916},{"$f":"K22*UserInput!$B$21","v":-51.880247192206525},{"$f":"L22*UserInput!$B$21","v":-20.612475556673456},{"$f":"M22*UserInput!$B$21","v":10.655296078859612},{"$f":"N22*UserInput!$B$21","v":29.979841702088951}]
[5,20.912593277451549,{"$f":"B39*UserInput!$B$14","v":17.775704285833815},{"$f":"UserInput!$B$21*COUNTIF(Coordinates!$G$3:$G$103,\">\"&UserInput!$B$3-'Calculations Circular'!C39-UserInput!$B$3/2)","v":3.9973122269451946},{"$f":"(UserInput!$B$3/2)^2*ACOS(((UserInput!$B$3/2)-C39)/(UserInput!$B$3/2))-((UserInput!$B$3/2)-C39)*SQRT(2*(UserInput!$B$3/2)*C39-C39^2)","v":500.86357313932092},{"$f":"2*(2*(UserInput!$B$3/2)*C39-C39^2)^(3/2)/(3*E39)","v":7.7607849510323632},-1702.9361486736912,{"$f":"D23*UserInput!$B$21","v":44.969762553133442},{"$f":"E23*UserInput!$B$21","v":44.969762553133457},{"$f":"F23*UserInput!$B$21","v":23.167711080772158},{"$f":"G23*UserInput!$B$21","v":-12.108749225983111},{"$f":"H23*UserInput!$B$21","v":-47.385209532738379},{"$f":"I23*UserInput!$B$21","v":-59.959683404177916},{"$f":"J23*UserInput!$B$21","v":-59.959683404177916},{"$f":"K23*UserInput!$B$21","v":-47.385209532738394},{"$f":"L23*UserInput!$B$21","v":-12.108749225983125},{"$f":"M23*UserInput!$B$21","v":23.16771108077214},{"$f":"N23*UserInput!$B$21","v":44.969762553133457}]
[6,18.778655187915678,{"$f":"B40*UserInput!$B$14","v":15.961856909728326},{"$f":"UserInput!$B$21*COUNTIF(Coordinates!$G$3:$G$103,\">\"&UserInput!$B$3-'Calculations Circular'!C40-UserInput!$B$3/2)","v":3.9973122269451946},{"$f":"(UserInput!$B$3/2)^2*ACOS(((UserInput!$B$3/2)-C40)/(UserInput!$B$3/2))-((UserInput!$B$3/2)-C40)*SQRT(2*(UserInput!$B$3/2)*C40-C40^2)","v":435.72194862099838},{"$f":"2*(2*(UserInput!$B$3/2)*C40-C40^2)^(3/2)/(3*E40)","v":8.7520670049509395},-1481.4546253113945,{"$f":"D24*UserInput!$B$21","v":59.959683404177916},{"$f":"E24*UserInput!$B$21","v":59.959683404177916},{"$f":"F24*UserInput!$B$21","v":35.680126082684666},{"$f":"G24*UserInput!$B$21","v":-3.6050228952927919},{"$f":"H24*UserInput!$B$21","v":-42.890171873270248},{"$f":"I24*UserInput!$B$21","v":-59.959683404177916},{"$f":"J24*UserInput!$B$21","v":-59.959683404177916},{"$f":"K24*UserInput!$B$21","v":-42.890171873270262},{"$f":"L24*UserInput!$B$21","v":-3.6050228952928083},{"$f":"M24*UserInput!$B$21","v":35.680126082684652},{"$f":"N24*UserInput!$B$21","v":59.959683404177916}]
[7,13.335566727650264,{"$f":"B41*UserInput!$B$14","v":11.335231718502724},{"$f":"UserInput!$B$21*COUNTIF(Coordinates!$G$3:$G$103,\">\"&UserInput!$B$3-'Calculations Circular'!C41-UserInput!$B$3/2)","v":3.9973122269451946},{"$f":"(UserInput!$B$3/2)^2*ACOS(((UserInput!$B$3/2)-C41)/(UserInput!$B$3/2))-((UserInput!$B$3/2)-C41)*SQRT(2*(UserInput!$B$3/2)*C41-C41^2)","v":274.60729370309411},{"$f":"2*(2*(UserInput!$B$3/2)*C41-C41^2)^(3/2)/(3*E41)","v":11.349006277842419},-933.66479859051992,{"$f":"D25*UserInput!$B$21","v":59.959683404177916},{"$f":"E25*UserInput!$B$21","v":59.959683404177916},{"$f":"F25*UserInput!$B$21","v":59.959683404177916},{"$f":"G25*UserInput!$B$21","v":30.409882427468517},{"$f":"H25*UserInput!$B$21","v":-24.910021235397696},{"$f":"I25*UserInput!$B$21","v":-59.099601953418833},{"$f":"J25*UserInput!$B$21","v":-59.099601953418848},{"$f":"K25*UserInput!$B$21","v":-24.910021235397721},{"$f":"L25*UserInput!$B$21","v":30.409882427468492},{"$f":"M25*UserInput!$B$21","v":59.959683404177916},{"$f":"N25*UserInput!$B$21","v":59.959683404177916}]
[8,10.338810159638969,{"$f":"B42*UserInput!$B$14","v":8.7879886356931234},{"$f":"UserInput!$B$21*COUNTIF(Coordinates!$G$3:$G$103,\">\"&UserInput!$B$3-'Calculations Circular'!C42-UserInput!$B$3/2)","v":1.9986561134725973},{"$f":"(UserInput!$B$3/2)^2*ACOS(((UserInput!$B$3/2)-C42)/(UserInput!$B$3/2))-((UserInput!$B$3/2)-C42)*SQRT(2*(UserInput!$B$3/2)*C42-C42^2)","v":192.41225552323405},{"$f":"2*(2*(UserInput!$B$3/2)*C42-C42^2)^(3/2)/(3*E42)","v":12.813011201270076},-654.20166877899578,{"$f":"D26*UserInput!$B$21","v":59.959683404177916},{"$f":"E26*UserInput!$B$21","v":59.959683404177916},{"$f":"F26*UserInput!$B$21","v":59.959683404177916},{"$f":"G26*UserInput!$B$21","v":59.959683404177916},{"$f":"H26*UserInput!$B$21","v":-6.9298705975251549},{"$f":"I26*UserInput!$B$21","v":-51.029474712074148},{"$f":"J26*UserInput!$B$21","v":-51.029474712074169},{"$f":"K26*UserInput!$B$21","v":-6.9298705975251842},{"$f":"L26*UserInput!$B$21","v":59.959683404177916},{"$f":"M26*UserInput!$B$21","v":59.959683404177916},{"$f":"N26*UserInput!$B$21","v":59.959683404177916}]
[9,8.4417807725492491,{"$f":"B43*UserInput!$B$14","v":7.1755136566668618},{"$f":"UserInput!$B$21*COUNTIF(Coordinates!$G$3:$G$103,\">\"&UserInput!$B$3-'Calculations Circular'!C43-UserInput!$B$3/2)","v":1.9986561134725973},{"$f":"(UserInput!$B$3/2)^2*ACOS(((UserInput!$B$3/2)-C43)/(UserInput!$B$3/2))-((UserInput!$B$3/2)-C43)*SQRT(2*(UserInput!$B$3/2)*C43-C43^2)","v":144.21889416181068},{"$f":"2*(2*(UserInput!$B$3/2)*C43-C43^2)^(3/2)/(3*E43)","v":13.750181729138649},-490.34424015015628,{"$f":"D27*UserInput!$B$21","v":59.959683404177916},{"$f":"E27*UserInput!$B$21","v":59.959683404177916},{"$f":"F27*UserInput!$B$21","v":59.959683404177916},{"$f":"G27*UserInput!$B$21","v":59.959683404177916},{"$f":"H27*UserInput!$B$21","v":11.050280040347403},{"$f":"I27*UserInput!$B$21","v":-42.959347470729462},{"$f":"J27*UserInput!$B$21","v":-42.959347470729483},{"$f":"K27*UserInput!$B$21","v":11.050280040347367},{"$f":"L27*UserInput!$B$21","v":59.959683404177916},{"$f":"M27*UserInput!$B$21","v":59.959683404177916},{"$f":"N27*UserInput!$B$21","v":59.959683404177916}]
[10,6.1755309007239481,{"$f":"B44*UserInput!$B$14","v":5.2492012656153557},{"$f":"UserInput!$B$21*COUNTIF(Coordinates!$G$3:$G$103,\">\"&UserInput!$B$3-'Calculations Circular'!C44-UserInput!$B$3/2)","v":1.9986561134725973},{"$f":"(UserInput!$B$3/2)^2*ACOS(((UserInput!$B$3/2)-C44)/(UserInput!$B$3/2))-((UserInput!$B$3/2)-C44)*SQRT(2*(UserInput!$B$3/2)*C44-C44^2)","v":91.88718388826274},{"$f":"2*(2*(UserInput!$B$3/2)*C44-C44^2)^(3/2)/(3*E44)","v":14.879153965728074},-312.41642522009329,{"$f":"D28*UserInput!$B$21","v":59.959683404177916},{"$f":"E28*UserInput!$B$21","v":59.959683404177916},{"$f":"F28*UserInput!$B$21","v":59.959683404177916},{"$f":"G28*UserInput!$B$21","v":59.959683404177916},{"$f":"H28*UserInput!$B$21","v":47.010581316092463},{"$f":"I28*UserInput!$B$21","v":-26.819092988040122},{"$f":"J28*UserInput!$B$21","v":-26.819092988040147},{"$f":"K28*UserInput!$B$21","v":47.010581316092413},{"$f":"L28*UserInput!$B$21","v":59.959683404177916},{"$f":"M28*UserInput!$B$21","v":59.959683404177916},{"$f":"N28*UserInput!$B$21","v":59.959683404177916}]
[11,4.8685402339040653,{"$f":"B45*UserInput!$B$14","v":4.1382591988184556},{"$f":"UserInput!$B$21*COUNTIF(Coordinates!$G$3:$G$103,\">\"&UserInput!$B$3-'Calculations Circular'!C45-UserInput!$B$3/2)","v":0},{"$f":"(UserInput!$B$3/2)^2*ACOS(((UserInput!$B$3/2)-C45)/(UserInput!$B$3/2))-((UserInput!$B$3/2)-C45)*SQRT(2*(UserInput!$B$3/2)*C45-C45^2)","v":64.97430633765623},{"$f":"2*(2*(UserInput!$B$3/2)*C45-C45^2)^(3/2)/(3*E45)","v":15.534521243022422},-220.91264154803119,{"$f":"D29*UserInput!$B$21","v":59.959683404177916},{"$f":"E29*UserInput!$B$21","v":59.959683404177916},{"$f":"F29*UserInput!$B$21","v":59.959683404177916},{"$f":"G29*UserInput!$B$21","v":59.959683404177916},{"$f":"H29*UserInput!$B$21","v":59.959683404177916},{"$f":"I29*UserInput!$B$21","v":-10.678838505350756},{"$f":"J29*UserInput!$B$21","v":-10.678838505350786},{"$f":"K29*UserInput!$B$21","v":59.959683404177916},{"$f":"L29*UserInput!$B$21","v":59.959683404177916},{"$f":"M29*UserInput!$B$21","v":59.959683404177916},{"$f":"N29*UserInput!$B$21","v":59.959683404177916}]
[12,4.0181401930474605,{"$f":"B46*UserInput!$B$14","v":3.4154191640903413},{"$f":"UserInput!$B$21*COUNTIF(Coordinates!$G$3:$G$103,\">\"&UserInput!$B$3-'Calculations Circular'!C46-UserInput!$B$3/2)","v":0},{"$f":"(UserInput!$B$3/2)^2*ACOS(((UserInput!$B$3/2)-C46)/(UserInput!$B$3/2))-((UserInput!$B$3/2)-C46)*SQRT(2*(UserInput!$B$3/2)*C46-C46^2)","v":49.033388582051458},{"$f":"2*(2*(UserInput!$B$3/2)*C46-C46^2)^(3/2)/(3*E46)","v":15.962505429250289},-166.71352117897496,{"$f":"D30*UserInput!$B$21","v":59.959683404177916},{"$f":"E30*UserInput!$B$21","v":59.959683404177916},{"$f":"F30*UserInput!$B$21","v":59.959683404177916},{"$f":"G30*UserInput!$B$21","v":59.959683404177916},{"$f":"H30*UserInput!$B$21","v":59.959683404177916},{"$f":"I30*UserInput!$B$21","v":5.4614159773385751},{"$f":"J30*UserInput!$B$21","v":5.461415977338536},{"$f":"K30*UserInput!$B$21","v":59.959683404177916},{"$f":"L30*UserInput!$B$21","v":59.959683404177916},{"$f":"M30*UserInput!$B$21","v":59.959683404177916},{"$f":"N30*UserInput!$B$21","v":59.959683404177916}]
[13,"N/A","N/A",{"$f":"UserInput!$B$21*COUNTIF(Coordinates!$G$3:$G$103,\">\"&UserInput!$B$3-'Calculations Circular'!C47-UserInput!$B$3/2)","v":0},0,0,0,{"$f":"D31*UserInput!$B$21","v":59.959683404177916},{"$f":"E31*UserInput!$B$21","v":59.959683404177916},{"$f":"F31*UserInput!$B$21","v":59.959683404177916},{"$f":"G31*UserInput!$B$21","v":59.959683404177916},{"$f":"H31*UserInput!$B$21","v":59.959683404177916},{"$f":"I31*UserInput!$B$21","v":59.959683404177916},{"$f":"J31*UserInput!$B$21","v":59.959683404177916},{"$f":"K31*UserInput!$B$21","v":59.959683404177916},{"$f":"L31*UserInput!$B$21","v":59.959683404177916},{"$f":"M31*UserInput!$B$21","v":59.959683404177916},{"$f":"N31*UserInput!$B$21","v":59.959683404177916}]
[]
["Results",null,null,null,null,null,"Factored Results",null,null,null,null,null,"Ecc. Factor",{"$f":"IF(UserInput!B13=\"Spirals\",0.85,IF(UserInput!B13=\"Ties\",0.8,\"Error\"))","v":0.85}]
["Point No.","P (kip)","M (kip*ft)","φ (1/in)","εs desc",null,"Tens. Strain εt","φ","φPn (kip)","φMn (kip*ft)",null,null,"fy",{"$f":"UserInput!B18","v":60}]
[1,4026.3981473072608,5.6843418860808015E-14,"N/A","compression",null,{"$f":"INDEX($E$3:$BB$15,A51,$N$53)","v":-3.0000000000000001E-3},{"$f":"IF(G51<=$N$51,0.75,IF(G51>=$N$52,0.9,(G51-$N$51)/($N$52-$N$51)*(0.9-0.75)+0.75))","v":0.75},{"$f":"H51*N49*B51","v":2566.8288189083787},{"$f":"H51*C51","v":4.2632564145606011E-14},null,null,"Comp Ctrl Strain εcl",{"$f":"IF(N50<=60,MIN(0.002,N50/UserInput!B19),(N50-60)/(100-60)*(0.004-0.002)+0.002)","v":2E-3}]
[{"$f":"A51+1","v":2},3124.8319032176641,919.56623346681624,9.4549379655973603E-5,"0εsy",null,{"$f":"INDEX($E$3:$BB$15,A52,$N$53)","v":0},{"$f":"IF(G52<=$N$51,0.75,IF(G52>=$N$52,0.9,(G52-$N$51)/($N$52-$N$51)*(0.9-0.75)+0.75))","v":0.75},{"$f":"MIN($I$51,H52*B52)","v":2343.6239274132481},{"$f":"H52*C52","v":689.67467510011215},null,null,"Tens Ctrl Strain εtl",{"$f":"IF(N50<=75,0.005,(N50-75)/(100-75)*(0.008-0.005)+0.005)","v":5.0000000000000001E-3}]
[3,2599.5148848668296,1225.0062931338236,1.1085099671431506E-4,0.25,null,5.1724137931034452E-4,0.75,{"$f":"MIN($I$51,H53*B53)","v":1949.6361636501222},918.75471985036779,null,null,"Bar No max tens",{"$f":"MATCH(MAX(E8:BB8),E8:BB8,0)","v":1}]
[4,2164.9645976885145,1374.3822561370434,1.2715261371374083E-4,{"$f":"E53+0.25","v":0.5},null,1.0344827586206895E-3,0.75,1623.7234482663857,1030.7866921027826]
[5,1805.5684857316787,1441.2241380358846,1.4345423064558686E-4,{"$f":"E54+0.25","v":0.75},null,1.5517241379310349E-3,0.75,1354.1763642987589,1080.9181035269135]
[6,1503.0847626831512,1466.0020458080371,1.5975584750118902E-4,{"$f":"E55+0.25","v":1},null,2.0689655172413794E-3,0.75344827586206897,1132.4966229181673,1104.5567138243314]
[7,801.02554649650438,1275.4741231405674,2.2496231398787798E-4,{"$f":"E56+1","v":2},null,4.1379310344827587E-3,0.85689655172413792,686.39602863579773,1092.9493779325207]
[8,410.36225897312693,1047.0904574829449,2.9016877856153994E-4,{"$f":"E57+1","v":3},null,6.2068965517241368E-3,0.9,369.32603307581422,942.38141173465044]
[9,194.40427458585299,866.53207954162554,3.553752406676746E-4,{"$f":"E58+1","v":4},null,8.2758620689655192E-3,0.9,174.96384712726768,779.87887158746298]
[10,-87.724651861078769,604.25794669887762,4.8578815525936062E-4,{"$f":"E59+2","v":6},null,1.2413793103448275E-2,0.9,-78.952186674970889,543.83215202898987]
[11,-237.40714867469049,447.61904136015829,6.16201053326936E-4,{"$f":"E60+2","v":8},null,1.6551724137931031E-2,0.9,-213.66643380722144,402.85713722414249]
[12,-323.88677800912546,346.46901384466645,7.4661393043440381E-4,{"$f":"E61+2","v":10},null,2.0689655172413793E-2,0.9,-291.49810020821292,311.82211246019983]
[13,-599.59683404177906,-5.6843418860808015E-14,"N/A","tension",null,{"$f":"INDEX($E$3:$BB$15,A63,$N$53)","v":2.0689655172413794E-3},0.9,-539.63715063760117,{"$f":"H63*C63","v":-5.1159076974727215E-14}]

{"sheet":"Calculations Rectangular","index":3,"n_rows":63,"n_cols":14,"rows_kept":63,"cut":false,"hidden":true,"merged":[]}
["Strains",null,null,null,"εsbars",null,null,null,"Bars on Top",{"$f":"UserInput!$B$5-J2","v":5}]
["εsmax description","c","εc","εsmax","top","bot",null,null,"Bars on Bot",{"$f":"INT(UserInput!$B$5/2+0.5)","v":5}]
["compression","N/A",{"$f":"-UserInput!$B$12","v":-3.0000000000000001E-3},-3.0000000000000001E-3,-3.0000000000000001E-3,{"$f":"D3","v":-3.0000000000000001E-3},null,null,"A bar",{"$f":"UserInput!B21","v":0.99932805673629865}]
["0εsy",{"$f":"(UserInput!$B$3-UserInput!$B$7-UserInput!$B$20/2)*(-C4/(D4-C4))","v":32.436},{"$f":"-UserInput!$B$12","v":-3.0000000000000001E-3},0,{"$f":"(B4-UserInput!$B$7-UserInput!$B$20/2)/B4*C4","v":-2.6703662597114316E-3},{"$f":"D4","v":0}]
[0.25,{"$f":"(UserInput!$B$3-UserInput!$B$7-UserInput!$B$20/2)*(-C5/(D5-C5))","v":27.666000000000004},{"$f":"-UserInput!$B$12","v":-3.0000000000000001E-3},{"$f":"A5*UserInput!$B$18/UserInput!$B$19","v":5.1724137931034484E-4},{"$f":"(B5-UserInput!$B$7-UserInput!$B$20/2)/B5*C5","v":-2.6135328562134031E-3},5.1724137931034484E-4]
[{"$f":"A5+0.25","v":0.5},{"$f":"(UserInput!$B$3-UserInput!$B$7-UserInput!$B$20/2)*(-C6/(D6-C6))","v":24.119076923076925},{"$f":"-UserInput!$B$12","v":-3.0000000000000001E-3},{"$f":"A6*UserInput!$B$18/UserInput!$B$19","v":1.0344827586206897E-3},{"$f":"(B6-UserInput!$B$7-UserInput!$B$20/2)/B6*C6","v":-2.5566994527153738E-3},1.0344827586206897E-3]
[{"$f":"A6+0.25","v":0.75},{"$f":"(UserInput!$B$3-UserInput!$B$7-UserInput!$B$20/2)*(-C7/(D7-C7))","v":21.378272727272726},{"$f":"-UserInput!$B$12","v":-3.0000000000000001E-3},{"$f":"A7*UserInput!$B$18/UserInput!$B$19","v":1.5517241379310344E-3},{"$f":"(B7-UserInput!$B$7-UserInput!$B$20/2)/B7*C7","v":-2.4998660492173445E-3},1.5517241379310344E-3]
[{"$f":"A7+0.25","v":1},{"$f":"(UserInput!$B$3-UserInput!$B$7-UserInput!$B$20/2)*(-C8/(D8-C8))","v":19.196816326530612},{"$f":"-UserInput!$B$12","v":-3.0000000000000001E-3},{"$f":"A8*UserInput!$B$18/UserInput!$B$19","v":2.0689655172413794E-3},{"$f":"(B8-UserInput!$B$7-UserInput!$B$20/2)/B8*C8","v":-2.4430326457193156E-3},2.0689655172413794E-3]
[{"$f":"A8+1","v":2},{"$f":"(UserInput!$B$3-UserInput!$B$7-UserInput!$B$20/2)*(-C9/(D9-C9))","v":13.632521739130434},{"$f":"-UserInput!$B$12","v":-3.0000000000000001E-3},{"$f":"A9*UserInput!$B$18/UserInput!$B$19","v":4.1379310344827587E-3},{"$f":"(B9-UserInput!$B$7-UserInput!$B$20/2)/B9*C9","v":-2.2156990317271997E-3},4.1379310344827587E-3]
[{"$f":"A9+1","v":3},{"$f":"(UserInput!$B$3-UserInput!$B$7-UserInput!$B$20/2)*(-C10/(D10-C10))","v":10.569033707865168},{"$f":"-UserInput!$B$12","v":-3.0000000000000001E-3},{"$f":"A10*UserInput!$B$18/UserInput!$B$19","v":6.2068965517241377E-3},{"$f":"(B10-UserInput!$B$7-UserInput!$B$20/2)/B10*C10","v":-1.9883654177350837E-3},6.2068965517241377E-3]
[{"$f":"A10+1","v":4},{"$f":"(UserInput!$B$3-UserInput!$B$7-UserInput!$B$20/2)*(-C11/(D11-C11))","v":8.6297614678899066},{"$f":"-UserInput!$B$12","v":-3.0000000000000001E-3},{"$f":"A11*UserInput!$B$18/UserInput!$B$19","v":8.2758620689655175E-3},{"$f":"(B11-UserInput!$B$7-UserInput!$B$20/2)/B11*C11","v":-1.7610318037429675E-3},8.2758620689655175E-3]
[{"$f":"A11+2","v":6},{"$f":"(UserInput!$B$3-UserInput!$B$7-UserInput!$B$20/2)*(-C12/(D12-C12))","v":6.3130469798657716},{"$f":"-UserInput!$B$12","v":-3.0000000000000001E-3},{"$f":"A12*UserInput!$B$18/UserInput!$B$19","v":1.2413793103448275E-2},{"$f":"(B12-UserInput!$B$7-UserInput!$B$20/2)/B12*C12","v":-1.3063645757587356E-3},1.2413793103448275E-2]
[{"$f":"A12+2","v":8},{"$f":"(UserInput!$B$3-UserInput!$B$7-UserInput!$B$20/2)*(-C13/(D13-C13))","v":4.9769523809523815},{"$f":"-UserInput!$B$12","v":-3.0000000000000001E-3},{"$f":"A13*UserInput!$B$18/UserInput!$B$19","v":1.6551724137931035E-2},{"$f":"(B13-UserInput!$B$7-UserInput!$B$20/2)/B13*C13","v":-8.5169734777450353E-4},1.6551724137931035E-2]
[{"$f":"A13+2","v":10},{"$f":"(UserInput!$B$3-UserInput!$B$7-UserInput!$B$20/2)*(-C14/(D14-C14))","v":4.1076157205240182},{"$f":"-UserInput!$B$12","v":-3.0000000000000001E-3},{"$f":"A14*UserInput!$B$18/UserInput!$B$19","v":2.0689655172413793E-2},{"$f":"(B14-UserInput!$B$7-UserInput!$B$20/2)/B14*C14","v":-3.9703011979027193E-4},2.0689655172413793E-2]
["tension","N/A",{"$f":"-UserInput!$B$12","v":-3.0000000000000001E-3},2.0689655172413794E-3,{"$f":"D15","v":2.0689655172413794E-3},2.0689655172413794E-3]
[]
["Stresses (ksi)"]
["Point No.","c","fc","fsmax","top","bot"]
[1,"N/A",{"$f":"0.85*UserInput!$B$11","v":3.4},{"$f":"IF(D3<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(D3>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Rectangular'!D3*UserInput!$B$19))","v":-60},{"$f":"IF(E3<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(E3>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Rectangular'!E3*UserInput!$B$19))","v":-60},{"$f":"IF(F3<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(F3>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Rectangular'!F3*UserInput!$B$19))","v":-60}]
[{"$f":"A19+1","v":2},{"$f":"B4","v":32.436},{"$f":"$C$19","v":3.4},{"$f":"IF(D4<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(D4>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Rectangular'!D4*UserInput!$B$19))","v":0},{"$f":"IF(E4<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(E4>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Rectangular'!E4*UserInput!$B$19))","v":-60},{"$f":"IF(F4<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(F4>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Rectangular'!F4*UserInput!$B$19))","v":0}]
[3,27.666000000000004,{"$f":"$C$19","v":3.4},{"$f":"IF(D5<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(D5>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Rectangular'!D5*UserInput!$B$19))","v":15},{"$f":"IF(E5<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(E5>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Rectangular'!E5*UserInput!$B$19))","v":-60},{"$f":"IF(F5<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(F5>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Rectangular'!F5*UserInput!$B$19))","v":15}]
[4,24.119076923076925,3.4,{"$f":"IF(D6<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(D6>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Rectangular'!D6*UserInput!$B$19))","v":30},{"$f":"IF(E6<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(E6>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Rectangular'!E6*UserInput!$B$19))","v":-60},{"$f":"IF(F6<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(F6>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Rectangular'!F6*UserInput!$B$19))","v":30}]
[5,21.378272727272726,3.4,{"$f":"IF(D7<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(D7>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Rectangular'!D7*UserInput!$B$19))","v":45},{"$f":"IF(E7<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(E7>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Rectangular'!E7*UserInput!$B$19))","v":-60},{"$f":"IF(F7<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(F7>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Rectangular'!F7*UserInput!$B$19))","v":45}]
[6,19.196816326530612,3.4,{"$f":"IF(D8<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(D8>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Rectangular'!D8*UserInput!$B$19))","v":60},{"$f":"IF(E8<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(E8>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Rectangular'!E8*UserInput!$B$19))","v":-60},{"$f":"IF(F8<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(F8>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Rectangular'!F8*UserInput!$B$19))","v":60}]
[7,13.632521739130434,3.4,{"$f":"IF(D9<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(D9>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Rectangular'!D9*UserInput!$B$19))","v":60},{"$f":"IF(E9<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(E9>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Rectangular'!E9*UserInput!$B$19))","v":-60},{"$f":"IF(F9<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(F9>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Rectangular'!F9*UserInput!$B$19))","v":60}]
[8,10.569033707865168,3.4,{"$f":"IF(D10<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(D10>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Rectangular'!D10*UserInput!$B$19))","v":60},{"$f":"IF(E10<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(E10>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Rectangular'!E10*UserInput!$B$19))","v":-57.662597114317428},{"$f":"IF(F10<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(F10>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Rectangular'!F10*UserInput!$B$19))","v":60}]
[9,8.6297614678899066,3.4,{"$f":"IF(D11<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(D11>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Rectangular'!D11*UserInput!$B$19))","v":60},{"$f":"IF(E11<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(E11>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Rectangular'!E11*UserInput!$B$19))","v":-51.069922308546055},{"$f":"IF(F11<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(F11>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Rectangular'!F11*UserInput!$B$19))","v":60}]
[10,6.3130469798657716,3.4,{"$f":"IF(D12<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(D12>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Rectangular'!D12*UserInput!$B$19))","v":60},{"$f":"IF(E12<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(E12>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Rectangular'!E12*UserInput!$B$19))","v":-37.884572697003328},{"$f":"IF(F12<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(F12>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Rectangular'!F12*UserInput!$B$19))","v":60}]
[11,4.9769523809523815,3.4,{"$f":"IF(D13<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(D13>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Rectangular'!D13*UserInput!$B$19))","v":60},{"$f":"IF(E13<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(E13>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Rectangular'!E13*UserInput!$B$19))","v":-24.699223085460602},{"$f":"IF(F13<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(F13>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Rectangular'!F13*UserInput!$B$19))","v":60}]
[12,4.1076157205240182,3.4,{"$f":"IF(D14<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(D14>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Rectangular'!D14*UserInput!$B$19))","v":60},{"$f":"IF(E14<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(E14>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Rectangular'!E14*UserInput!$B$19))","v":-11.513873473917887},{"$f":"IF(F14<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(F14>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Rectangular'!F14*UserInput!$B$19))","v":60}]
[13,"N/A",3.4,{"$f":"IF(D15<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(D15>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Rectangular'!D15*UserInput!$B$19))","v":60},{"$f":"IF(E15<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(E15>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Rectangular'!E15*UserInput!$B$19))","v":60},{"$f":"IF(F15<-UserInput!$B$18/UserInput!$B$19,-UserInput!$B$18,IF(F15>UserInput!$B$18/UserInput!$B$19,UserInput!$B$18,'Calculations Rectangular'!F15*UserInput!$B$19))","v":60}]
[]
["Forces (kip)"]
["Point No.","c","a=β'c","Ascomp","Accomp","C arm","S_top arm","S_bot arm","C","top","bot"]
[1,"N/A","N/A",{"$f":"UserInput!$B$21*UserInput!$B$5","v":9.9932805673629872},{"$f":"UserInput!$B$15","v":1007.88273919573},0,0,0,{"$f":"-E35*C19","v":-3426.8013132654819},{"$f":"E19*$J$1*$J$3","v":-299.79841702088959},{"$f":"F19*$J$2*$J$3","v":-299.79841702088959}]
[{"$f":"A35+1","v":2},{"$f":"B20","v":32.436},{"$f":"B36*UserInput!$B$14","v":27.570599999999999},{"$f":"UserInput!$B$21*(IF(E20<0,$J$1,0)+IF(F20<0,$J$2,0))","v":4.9966402836814936},{"$f":"C36*UserInput!$B$4-IF(J36<0,$J$1*$J$3)-IF(K36<0,$J$2*$J$3)","v":656.6977597163185},{"$f":"UserInput!$B$3/2-C36/2","v":4.2147000000000006},{"$f":"UserInput!$B$3/2-UserInput!$B$7-UserInput!$B$20/2","v":14.436},{"$f":"UserInput!$B$3/2-UserInput!$B$7-UserInput!$B$20/2","v":14.436},-2232.772383035483,-299.79841702088959,0]
[3,27.666000000000004,{"$f":"B37*UserInput!$B$14","v":23.516100000000002},{"$f":"UserInput!$B$21*(IF(E21<0,$J$1,0)+IF(F21<0,$J$2,0))","v":4.9966402836814936},{"$f":"C37*UserInput!$B$4-IF(J37<0,$J$1*$J$3)-IF(K37<0,$J$2*$J$3)","v":559.38975971631862},{"$f":"UserInput!$B$3/2-C37/2","v":6.2419499999999992},{"$f":"UserInput!$B$3/2-UserInput!$B$7-UserInput!$B$20/2","v":14.436},{"$f":"UserInput!$B$3/2-UserInput!$B$7-UserInput!$B$20/2","v":14.436},-1901.9251830354833,-299.79841702088959,74.949604255222397]
[4,24.119076923076925,{"$f":"B38*UserInput!$B$14","v":20.501215384615385},{"$f":"UserInput!$B$21*(IF(E22<0,$J$1,0)+IF(F22<0,$J$2,0))","v":4.9966402836814936},{"$f":"C38*UserInput!$B$4-IF(J38<0,$J$1*$J$3)-IF(K38<0,$J$2*$J$3)","v":487.03252894708777},{"$f":"UserInput!$B$3/2-C38/2","v":7.7493923076923075},{"$f":"UserInput!$B$3/2-UserInput!$B$7-UserInput!$B$20/2","v":14.436},{"$f":"UserInput!$B$3/2-UserInput!$B$7-UserInput!$B$20/2","v":14.436},-1655.9105984200983,-299.79841702088959,149.89920851044479]
[5,21.378272727272726,{"$f":"B39*UserInput!$B$14","v":18.171531818181816},{"$f":"UserInput!$B$21*(IF(E23<0,$J$1,0)+IF(F23<0,$J$2,0))","v":4.9966402836814936},{"$f":"C39*UserInput!$B$4-IF(J39<0,$J$1*$J$3)-IF(K39<0,$J$2*$J$3)","v":431.12012335268207},{"$f":"UserInput!$B$3/2-C39/2","v":8.9142340909090922},{"$f":"UserInput!$B$3/2-UserInput!$B$7-UserInput!$B$20/2","v":14.436},{"$f":"UserInput!$B$3/2-UserInput!$B$7-UserInput!$B$20/2","v":14.436},-1465.808419399119,-299.79841702088959,224.84881276566719]
[6,19.196816326530612,{"$f":"B40*UserInput!$B$14","v":16.31729387755102},{"$f":"UserInput!$B$21*(IF(E24<0,$J$1,0)+IF(F24<0,$J$2,0))","v":4.9966402836814936},{"$f":"C40*UserInput!$B$4-IF(J40<0,$J$1*$J$3)-IF(K40<0,$J$2*$J$3)","v":386.61841277754297},{"$f":"UserInput!$B$3/2-C40/2","v":9.8413530612244902},{"$f":"UserInput!$B$3/2-UserInput!$B$7-UserInput!$B$20/2","v":14.436},{"$f":"UserInput!$B$3/2-UserInput!$B$7-UserInput!$B$20/2","v":14.436},-1314.502603443646,-299.79841702088959,299.79841702088959]
[7,13.632521739130434,{"$f":"B41*UserInput!$B$14","v":11.587643478260869},{"$f":"UserInput!$B$21*(IF(E25<0,$J$1,0)+IF(F25<0,$J$2,0))","v":4.9966402836814936},{"$f":"C41*UserInput!$B$4-IF(J41<0,$J$1*$J$3)-IF(K41<0,$J$2*$J$3)","v":273.10680319457936},{"$f":"UserInput!$B$3/2-C41/2","v":12.206178260869565},{"$f":"UserInput!$B$3/2-UserInput!$B$7-UserInput!$B$20/2","v":14.436},{"$f":"UserInput!$B$3/2-UserInput!$B$7-UserInput!$B$20/2","v":14.436},-928.56313086156979,-299.79841702088959,299.79841702088959]
[8,10.569033707865168,{"$f":"B42*UserInput!$B$14","v":8.983678651685393},{"$f":"UserInput!$B$21*(IF(E26<0,$J$1,0)+IF(F26<0,$J$2,0))","v":4.9966402836814936},{"$f":"C42*UserInput!$B$4-IF(J42<0,$J$1*$J$3)-IF(K42<0,$J$2*$J$3)","v":210.61164735676792},{"$f":"UserInput!$B$3/2-C42/2","v":13.508160674157303},{"$f":"UserInput!$B$3/2-UserInput!$B$7-UserInput!$B$20/2","v":14.436},{"$f":"UserInput!$B$3/2-UserInput!$B$7-UserInput!$B$20/2","v":14.436},-716.07960101301092,-288.1192556030947,299.79841702088959]
[9,8.6297614678899066,{"$f":"B43*UserInput!$B$14","v":7.3352972477064204},{"$f":"UserInput!$B$21*(IF(E27<0,$J$1,0)+IF(F27<0,$J$2,0))","v":4.9966402836814936},{"$f":"C43*UserInput!$B$4-IF(J43<0,$J$1*$J$3)-IF(K43<0,$J$2*$J$3)","v":171.05049366127258},{"$f":"UserInput!$B$3/2-C43/2","v":14.332351376146789},{"$f":"UserInput!$B$3/2-UserInput!$B$7-UserInput!$B$20/2","v":14.436},{"$f":"UserInput!$B$3/2-UserInput!$B$7-UserInput!$B$20/2","v":14.436},-581.57167844832679,-255.17803109136537,299.79841702088959]
[10,6.3130469798657716,{"$f":"B44*UserInput!$B$14","v":5.366089932885906},{"$f":"UserInput!$B$21*(IF(E28<0,$J$1,0)+IF(F28<0,$J$2,0))","v":4.9966402836814936},{"$f":"C44*UserInput!$B$4-IF(J44<0,$J$1*$J$3)-IF(K44<0,$J$2*$J$3)","v":123.78951810558024},{"$f":"UserInput!$B$3/2-C44/2","v":15.316955033557047},{"$f":"UserInput!$B$3/2-UserInput!$B$7-UserInput!$B$20/2","v":14.436},{"$f":"UserInput!$B$3/2-UserInput!$B$7-UserInput!$B$20/2","v":14.436},-420.88436155897284,-189.29558206790688,299.79841702088959]
[11,4.9769523809523815,{"$f":"B45*UserInput!$B$14","v":4.2304095238095245},{"$f":"UserInput!$B$21*(IF(E29<0,$J$1,0)+IF(F29<0,$J$2,0))","v":4.9966402836814936},{"$f":"C45*UserInput!$B$4-IF(J45<0,$J$1*$J$3)-IF(K45<0,$J$2*$J$3)","v":96.533188287747095},{"$f":"UserInput!$B$3/2-C45/2","v":15.884795238095238},{"$f":"UserInput!$B$3/2-UserInput!$B$7-UserInput!$B$20/2","v":14.436},{"$f":"UserInput!$B$3/2-UserInput!$B$7-UserInput!$B$20/2","v":14.436},-328.21284017834012,-123.41313304444834,299.79841702088959]
[12,4.1076157205240182,{"$f":"B46*UserInput!$B$14","v":3.4914733624454155},{"$f":"UserInput!$B$21*(IF(E30<0,$J$1,0)+IF(F30<0,$J$2,0))","v":4.9966402836814936},{"$f":"C46*UserInput!$B$4-IF(J46<0,$J$1*$J$3)-IF(K46<0,$J$2*$J$3)","v":78.798720415008489},{"$f":"UserInput!$B$3/2-C46/2","v":16.254263318777291},{"$f":"UserInput!$B$3/2-UserInput!$B$7-UserInput!$B$20/2","v":14.436},{"$f":"UserInput!$B$3/2-UserInput!$B$7-UserInput!$B$20/2","v":14.436},-267.91564941102888,-57.530684020989888,299.79841702088959]
[13,"N/A","N/A",{"$f":"UserInput!$B$21*(IF(E31<0,$J$1,0)+IF(F31<0,$J$2,0))","v":0},0,0,0,0,0,299.79841702088959,299.79841702088959]
[]
["Results",null,null,null,null,null,"Factored Results",null,null,null,null,null,"Ecc. Factor",{"$f":"IF(UserInput!B13=\"Spirals\",0.85,IF(UserInput!B13=\"Ties\",0.8,\"Error\"))","v":0.85}]
["Point No.","P (kip)","M (kip*ft)","εsmax description",null,null,"Tens. Strain εt","φ","φPn (kip)","φMn (kip*ft)",null,null,"fy",{"$f":"UserInput!B18","v":60}]
[1,{"$f":"-SUM(I35:K35)","v":4026.3981473072613},{"$f":"(-I35*F35+-J35*G35+K35*H35)/12","v":0},"compression",null,null,{"$f":"F3","v":-3.0000000000000001E-3},{"$f":"IF(G51<=$N$51,0.75,IF(G51>=$N$52,0.9,(G51-$N$51)/($N$52-$N$51)*(0.9-0.75)+0.75))","v":0.75},{"$f":"H51*N49*B51","v":2566.8288189083787},{"$f":"H51*C51","v":0},null,null,"Comp Ctrl Strain εcl",{"$f":"IF(N50<=60,MIN(0.002,N50/UserInput!B19),(N50-60)/(100-60)*(0.004-0.002)+0.002)","v":2E-3}]
[{"$f":"A51+1","v":2},{"$f":"-SUM(I36:K36)","v":2532.5708000563727},{"$f":"(-I36*F36+-J36*G36+K36*H36)/12","v":1144.8629759077678},"0εsy",null,null,{"$f":"F4","v":0},{"$f":"IF(G52<=$N$51,0.75,IF(G52>=$N$52,0.9,(G52-$N$51)/($N$52-$N$51)*(0.9-0.75)+0.75))","v":0.75},{"$f":"MIN($I$51,H52*B52)","v":1899.4281000422795},{"$f":"H52*C52","v":858.64723193082591},null,null,"Tens Ctrl Strain εtl",{"$f":"IF(N50<=75,0.005,(N50-75)/(100-75)*(0.008-0.005)+0.005)","v":5.0000000000000001E-3}]
[3,2126.7739958011507,1440.1320276158569,0.25,null,null,5.1724137931034484E-4,0.75,{"$f":"MIN($I$51,H53*B53)","v":1595.080496850863},1080.0990207118928]
[4,1805.8098069305431,1610.344647982768,{"$f":"D53+0.25","v":0.5},null,null,1.0344827586206897E-3,0.75,1354.3573551979073,1207.758485987076]
[5,1540.7580236543415,1720.0305660123279,{"$f":"D54+0.25","v":0.75},null,null,1.5517241379310344E-3,0.75,1155.5685177407561,1290.022924509246]
[6,1314.502603443646,1799.3553430512345,{"$f":"D55+0.25","v":1},null,null,2.0689655172413794E-3,0.75344827586206897,990.40972018081607,1355.7211808851544]
[7,928.5631308615699,1665.8322498328835,{"$f":"D56+1","v":2},null,null,4.1379310344827587E-3,0.85689655172413792,795.68254489344872,1427.4459106326606]
[8,704.40043959521597,1513.3414856641702,{"$f":"D57+1","v":3},null,null,6.2068965517241377E-3,0.9,633.96039563569434,1362.0073370977532]
[9,536.95129251880257,1362.2441375737824,{"$f":"D58+1","v":4},null,null,8.2758620689655175E-3,0.9,483.25616326692233,1226.0197238164042]
[10,310.38152660599019,1125.6023175976682,{"$f":"D59+2","v":6},null,null,1.2413793103448275E-2,0.9,279.34337394539119,1013.0420858379014]
[11,151.82755620189886,943.58964145748575,{"$f":"D60+2","v":8},null,null,1.6551724137931035E-2,0.9,136.64480058170898,849.23067731173717]
[12,25.647916411129188,792.76453461572135,{"$f":"D61+2","v":10},null,null,2.0689655172413793E-2,0.9,23.083124770016269,713.4880811541492]
[13,-599.59683404177918,0,"tension",null,null,2.0689655172413794E-3,0.9,-539.63715063760128,{"$f":"H63*C63","v":0}]

{"sheet":"Results","index":4,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":true,"merged":[[0,3,0,4],[0,5,0,6]]}
[null,null,null,"Nominal",null,"Factored"]
[null,"Point No.","Description","P (kip)","M (kip*ft)","P (kip)","M (kip*ft)"]
[null,1,"Compression",4026.3981473072608,5.6843418860808015E-14,2566.8288189083787,4.2632564145606011E-14]
[null,2,"εsmax=0εsy",3124.8319032176641,919.56623346681624,2343.6239274132481,689.67467510011215]
[null,3,"εsmax=0.25εsy",2599.5148848668296,1225.0062931338236,1949.6361636501222,918.75471985036779]
[null,4,"εsmax=0.5εsy",2164.9645976885145,1374.3822561370434,1623.7234482663857,1030.7866921027826]
[null,5,"εsmax=0.75εsy",1805.5684857316787,1441.2241380358846,1354.1763642987589,1080.9181035269135]
[null,6,"Balanced",1503.0847626831512,1466.0020458080371,1132.4966229181673,1104.5567138243314]
[null,7,"εsmax=2εsy",801.02554649650438,1275.4741231405674,686.39602863579773,1092.9493779325207]
[null,8,"εsmax=3εsy",410.36225897312693,1047.0904574829449,369.32603307581422,942.38141173465044]
[null,9,"εsmax=4εsy",194.40427458585299,866.53207954162554,174.96384712726768,779.87887158746298]
[null,10,"εsmax=6εsy",-87.724651861078769,604.25794669887762,-78.952186674970889,543.83215202898987]
[null,11,"εsmax=8εsy",-237.40714867469049,447.61904136015829,-213.66643380722144,402.85713722414249]
[null,12,"εsmax=10εsy",-323.88677800912546,346.46901384466645,-291.49810020821292,311.82211246019983]
[null,13,"Tension",-599.59683404177906,-5.6843418860808015E-14,-539.63715063760117,-5.1159076974727215E-14]
[]
[null,null,null,null,"Nominal",null,"Factored"]
[null,null,null,"  Approx. Pure Bending Capacity (kip*ft):",685.80898538729855,"  Approx. Pure Bending Capacity (kip*ft):",617.22808684856864]

{"sheet":"Comparison","index":5,"n_rows":40,"n_cols":5,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
["Circular 36\" diameter, 10 #9's, 3\" clr, 4ksi conc, 60ksi steel"]
["SpColumn",null,null,"This Excel"]
["P","M",null,"P","M"]
[2567.1,0,null,2566.8288189083787,4.2632564145606011E-14]
[2567.1,476.06,null,2343.6239274132481,689.67467510011215]
[2377.4,638.16,null,1949.6361636501222,918.75471985036779]
[1662.5,1008.48,null,1623.7234482663857,1030.7866921027826]
[1163.3,1090.82,null,1354.1763642987589,1080.9181035269135]
[561,1059.92,null,1132.4966229181673,1104.5567138243314]
[0,624.04,null,686.39602863579773,1092.9493779325207]
[-540,0,null,369.32603307581422,942.38141173465044]
[null,null,null,174.96384712726768,779.87887158746298]
[null,null,null,-78.952186674970889,543.83215202898987]
[null,null,null,-213.66643380722144,402.85713722414249]
[null,null,null,-291.49810020821292,311.82211246019983]
[null,null,null,-539.63715063760117,-5.1159076974727215E-14]
[]
[]
[]
[]
[]
[]
[]
[]
["Rectangular 16\"H, 12\"W, 8 #5's, 2.6875 clr, 4ksi conc, 60ksi steel"]
["SpColumn",null,null,"This Excel"]
["P","M",null,"P","M"]
[505.6,0,null,504.71977884621379,0]
[505.6,46.48,null,390.2239875565964,92.103601901781744]
[390.8,91.67,null,326.69316046562562,106.91578938502619]
[276.2,115.1,null,275.91233337465479,115.03985743784156]
[190.5,121.38,null,230.34895527667686,118.74736440178992]
[116.9,116.41,null,191.4929118648935,121.56878535823279]
[0,68.63,null,136.95209441041641,118.6123147356485]
[-133.9,0,null,90.225923069743104,105.66018043810378]
[null,null,null,50.674116578922096,89.623198309988737]
[null,null,null,-5.1367022896891328,65.749335691605026]
[null,null,null,-52.435706382130782,44.541475949055979]
[null,null,null,-81.151992475066109,31.259970522587299]
[null,null,null,-132.53594007331941,0]